package com.oydsoft.service.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oydsoft.dto.system.dto.S03Dto;
import com.oydsoft.dto.system.po.S03;
import com.oydsoft.dto.system.vo.S03Vo;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface S03Mapper extends BaseMapper<S03> {

    @Select({"<script>",
            "SELECT * FROM s03",
            "WHERE 1=1",
            "<when test=\"s0304!=null and s0304!=''\">",
            "AND s0304 like CONCAT('%',#{s0304},'%')",
            "</when>",
            " AND z0011 != '3'",
            /*"AND TO_DAYS(created_date) = TO_DAYS(NOW()) ",*/
            "</script>"})
    List<S03Vo> getS03List(S03Dto s03);
}
